﻿CREATE TABLE [dbo].[Client] (
    [Id]        BIGINT       NOT NULL IDENTITY,
    [AddressId] BIGINT       NOT NULL,
    [Name]      VARCHAR (30) NOT NULL,
    [LastName]  VARCHAR (30) NOT NULL,
    [Email]     VARCHAR (60) NOT NULL,
    [Pesel]     VARCHAR (11) NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Client_Address] FOREIGN KEY ([AddressId]) REFERENCES [dbo].[Address] ([Id])
);

